package com.liliang.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.liliang.entity.Orders;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author liliang
 * @since 2021-11-04
 */
public interface OrdersMapper extends BaseMapper<Orders> {

    List<Map> findMaterialPage(@Param("page") Integer page, @Param("max")Integer max, @Param("materialCode")String materialCode, @Param("materialName")String materialName, @Param("zt") String zt);

    Integer findOrdersCountLike(@Param("materialCode")String materialCode, @Param("materialName")String materialName, @Param("zt") String zt);

    Integer findOrdersCountLike2(@Param("materialCode")String materialCode, @Param("materialName")String materialName);

    List<Map> findMaterialPage2(@Param("page") Integer page, @Param("max")Integer max,@Param("sort")String sort,@Param("order") String order,@Param("materialCode")String materialCode, @Param("materialName")String materialName);

    List<Orders> findBYstockid(@Param("id")long id);
}
